<?php
ini_set('memory_limit', '1576M');
set_time_limit(0);
require_once dirname(__FILE__) . '/PHPExcel/PHPExcel.php';

$filename = dirname(__FILE__) . '/xls/test_data.xls';
$outputname = dirname(__FILE__) . '/xls/test_data.txt';

$objReader = new PHPExcel_Reader_Excel5();
$objReader->setReadDataOnly(true);
$objPHPExcel = $objReader->load( $filename );

$rowIterator = $objPHPExcel->getActiveSheet()->getRowIterator();
$sheet = $objPHPExcel->getActiveSheet();
$array_data = array();
foreach($rowIterator as $row){
	$rowIndex = $row->getRowIndex();
	$array_data[$rowIndex] = array('A'=>'', 'B'=>'','C'=>'','D'=>'');
	
	$cell = $sheet->getCell('A' . $rowIndex);
	$array_data[$rowIndex]['A'] = $cell->getCalculatedValue();
	$cell = $sheet->getCell('B' . $rowIndex);
	$array_data[$rowIndex]['B'] = $cell->getCalculatedValue();
	$cell = $sheet->getCell('C' . $rowIndex);
	$array_data[$rowIndex]['C'] = PHPExcel_Style_NumberFormat::toFormattedString($cell->getCalculatedValue(), 'YYYY-MM-DD');
	$cell = $sheet->getCell('D' . $rowIndex);
	$array_data[$rowIndex]['D'] = $cell->getCalculatedValue();
}
print_r($array_data);
